Excel Dashboards and Reports for Dummies by Michael Alexander

Author:Michael Alexander [Alexander, Michael]
Language: eng
Format: epub, pdf
ISBN: 9781119076773
Publisher: Wiley
Published: 2016-01-05T00:00:00+00:00

Figure 6-50 illustrates the settings that convert the second Sum of Sales Amount field into a month-over-month variance calculation.

Figure 6-50: Configure the second Sum of Sales Amount field to show month-over-month variance.

As you can see, after the settings are applied, the pivot table gives you a nice view of raw sales dollars and the variance over last month. You can obviously change the field names (see the section “Customizing field names,” earlier in this chapter) to reflect the appropriate labels for each column.

In the sample data for this chapter, you don’t see Months and Years. You have to create them by grouping the SalesDate field. Feel free to review the section “Creating views by month, quarter, and year,” earlier in this chapter, to find out how.

To create the view in Figure 6-50, take these actions:

Right-click any value within the target field.

In this case, the target field is the second Sum of Sales Amount field.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.